UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7bu8TZlSFTWuJc1kgbLuU6XCj5P8NWMB3zs6wlWjOsM='
WHERE
key_id = '8a93bd05aae4664608d0bcf9c55d3a22c5fd44fa0813ad336ccf0df14021f5e4'
AND (
token = '7bu8TZlSFTWuJc1kgbLuU6XCj5P8NWMB3zs6wlWjOsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)