UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WbPZ0GH8kt69TJJuH/nErFT9WwJisFYPj9jSnSobySU='
WHERE
key_id = 'be20a665a1acbe76e63aca949198ba78870c8b732b9abd87bac016eea9431cab'
AND (
token = 'WbPZ0GH8kt69TJJuH/nErFT9WwJisFYPj9jSnSobySU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)