UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f9SP0ggfW66tQUmwAov8orUFrUuwbOock9/nxRArhgo='
WHERE
key_id = '25dc7b7b5d8e2499449a4a8b67c28c9f7f5b5601120efe8370f2ec680455b32d'
AND (
token = 'f9SP0ggfW66tQUmwAov8orUFrUuwbOock9/nxRArhgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)