UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'abJyy68bGN6NGK+8WEVAZuVY+E+3aUeL/nNWnYK0MiU='
WHERE
key_id = 'e83c5e936cde37ad2dea93c24c0c3681d2f8844e093becd0b0632cd552764fa5'
AND (
token = 'abJyy68bGN6NGK+8WEVAZuVY+E+3aUeL/nNWnYK0MiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)