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