UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XGOuQ2LEz8e+xDpHO/DCmKFkfdiJ2VTet/yzphKDFpA='
WHERE
key_id = '9df439cd7950689dbda44974feffa36ca4a1f60a677d76cee1f9c6152de6d735'
AND (
token = 'XGOuQ2LEz8e+xDpHO/DCmKFkfdiJ2VTet/yzphKDFpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)