UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lmCXi42BepVlGEbzJd51Ah2FYpc5o5au5qc6YuKTYpw='
WHERE
key_id = '164e3ba17da1b6a0fbbcdac10f8b45e504abca7826026f5d02eab50efce1ebae'
AND (
token = 'lmCXi42BepVlGEbzJd51Ah2FYpc5o5au5qc6YuKTYpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)