UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JcfVioZWwQbPKPJT4enp819xZiIdkp1AnW+B6G7wRCM='
WHERE
key_id = '6da34a4c68e112e2eac41f0cff7759dfc53ea3de116fba5ae1181cdbb294fe07'
AND (
token = 'JcfVioZWwQbPKPJT4enp819xZiIdkp1AnW+B6G7wRCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)