UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vR1whOOn/UQhatI4cWjlv6wn+R0pZGaX5x72oi3QcKE='
WHERE
key_id = '4e7739cf9c0c9317524562ad004fdfc9274028f3bbb9651261982661f0ce7bad'
AND (
token = 'vR1whOOn/UQhatI4cWjlv6wn+R0pZGaX5x72oi3QcKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)