UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WKVtlhzjWsu0aP4fa37jLMn3FpnAHqn0xH83FcLIxmc='
WHERE
key_id = '3efb0f8e61e59d829d32b17b080fd23e14aa5b18b0d0c73abe28ff551ce07826'
AND (
token = 'WKVtlhzjWsu0aP4fa37jLMn3FpnAHqn0xH83FcLIxmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)