UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lz9ib30y/ZTc8gXqrFkq8Ofya8q9UrOvlfziREkE7iM='
WHERE
key_id = '2dc3bee0b0d7ab6dbe24a81fa5102317a501e8385e0a5e4f2efe93a8bf590447'
AND (
token = 'lz9ib30y/ZTc8gXqrFkq8Ofya8q9UrOvlfziREkE7iM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)