UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EoxRgpe1yWeanqQy5eXGLdfv2WsOxCi0pkjeoaqOywU='
WHERE
key_id = '9ba5a055943f7eaa682235778a4ff4f2cd44771a10f50849c6335ef16023629e'
AND (
token = 'EoxRgpe1yWeanqQy5eXGLdfv2WsOxCi0pkjeoaqOywU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)