UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TCn3725+ePyTh5mng0uocHD1uQSxjOK/D/Ih1Vq/P9E='
WHERE
key_id = '1a4a9fd2f54ab726ca6dcea73a6e0cc17d94d2acf73ec1fd1fcea11f02f66ff8'
AND (
token = 'TCn3725+ePyTh5mng0uocHD1uQSxjOK/D/Ih1Vq/P9E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)