UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tPZ+j2vfBJah5PwjdoD4TSa0elgRfZj+ob1jWI23iWw='
WHERE
key_id = 'af5c25668768033f8900a49783df25a060d0ea2a8f67ab55045746b6a7a7ee39'
AND (
token = 'tPZ+j2vfBJah5PwjdoD4TSa0elgRfZj+ob1jWI23iWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)