UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9B7F3Jr5kA8+0K1x+E56y4mraPSjrKFM62fk/Yzdwto='
WHERE
key_id = 'b27cfc08c1e104629a85c7cf12a0239bd7fa5391cebcd15f4c3e38f4f470c78b'
AND (
token = '9B7F3Jr5kA8+0K1x+E56y4mraPSjrKFM62fk/Yzdwto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)