UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KrYKlRPc6Kzpt7cPtyO4MqGRuve9R4wLspZhFr3WxpU='
WHERE
key_id = 'd4fd8ec44b3774898335a65555a8d83a216a3b13d0abde7fc05f4c1ff76b3f6c'
AND (
token = 'KrYKlRPc6Kzpt7cPtyO4MqGRuve9R4wLspZhFr3WxpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)