UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K1cDXjMtXcACEE2v9Huj9gec6doCko2lMDlowdcfB38='
WHERE
key_id = '79f1f6f26f5f37f5e1677c426caf4712355df3b731b373a82fa09603236f865a'
AND (
token = 'K1cDXjMtXcACEE2v9Huj9gec6doCko2lMDlowdcfB38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)