UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dQ2gOwcopcK/LN1BMBeFeMxLUK5YslMCjKUYWSwn/xo='
WHERE
key_id = 'f00a9f0bc61e17023c3b437adca4faecac819230557fe29953bf3ad9e48ec0a3'
AND (
token = 'dQ2gOwcopcK/LN1BMBeFeMxLUK5YslMCjKUYWSwn/xo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)