UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pESUCcZiVCC5Z08ugOD5ZbIYHhQQLnPnzPPzS+gyi+A='
WHERE
key_id = '7e2346f2e56a4ee12479c1c3796f2ab60e34187ce612e049ceaab0bcdd5eea83'
AND (
token = 'pESUCcZiVCC5Z08ugOD5ZbIYHhQQLnPnzPPzS+gyi+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)