UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xS8n0NzV9hyJqENbQN6cBM/LFje0R368EGr6jMmj8HQ='
WHERE
key_id = 'e4be706d56031a0be1be01a61d6b2e888cce5e234fd371fb041a3d60de7d0a6f'
AND (
token = 'xS8n0NzV9hyJqENbQN6cBM/LFje0R368EGr6jMmj8HQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)