UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a7IBiZWwSWpN4zqeelEH2dIi2F4fnviBqNT8U8dmxkE='
WHERE
key_id = 'f9e5a0c6a03de59a984c4e01b48a74972fffbb66b4f45e8a33ee692c28465410'
AND (
token = 'a7IBiZWwSWpN4zqeelEH2dIi2F4fnviBqNT8U8dmxkE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)