UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G40RNhjCEA1vNlCEgpLs1EvkPZrkaDjnZdXLaKPutVQ='
WHERE
key_id = '9fddf67ebe3aecb99d442b947b09603365b4d818cb6310c38d4b51f5669cda13'
AND (
token = 'G40RNhjCEA1vNlCEgpLs1EvkPZrkaDjnZdXLaKPutVQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)