UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nejzXoid2HOW0VF3BJc1ELeXqxUGkrX4wj1LO8jF9og='
WHERE
key_id = '6d4faf714ec1b809f1703cf9c8017219b3c1001f4f90d7ba384159e8c64e1c8c'
AND (
token = 'nejzXoid2HOW0VF3BJc1ELeXqxUGkrX4wj1LO8jF9og='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)