UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bdje9R7+u7cQ+HuicOyTlcs/RM7uIR417VDgKRt7dko='
WHERE
key_id = 'a7e816b4d76f0b8c66ae341b1ba106b951e19594ba5042f36742d075129dac30'
AND (
token = 'bdje9R7+u7cQ+HuicOyTlcs/RM7uIR417VDgKRt7dko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)