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