UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZCoFpgt9WpT5jX5p0oAuYaHOLUxUOKohIfGvVM+9hpI='
WHERE
key_id = '88f8838bd029f4c80c1bd3dd39707c6b8a3418b39988222862d281ea4687604a'
AND (
token = 'ZCoFpgt9WpT5jX5p0oAuYaHOLUxUOKohIfGvVM+9hpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)