UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZdWRC971bcc1h6wshnpxwHRxrJQahqkVZ2vPJrgtBEU='
WHERE
key_id = 'b9224c9fa295fdf984cdf9063eaa2463cf7a293b28e088497e72808731c2f27d'
AND (
token = 'ZdWRC971bcc1h6wshnpxwHRxrJQahqkVZ2vPJrgtBEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)