UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WggMcAxd1qXt6w7INvm79prpG2C9ZxRRloI9/fVtkcQ='
WHERE
key_id = 'ae06f832d6d046ea35144d50742b77bc995623fc5cc4f5493008eba90a5f8c6a'
AND (
token = 'WggMcAxd1qXt6w7INvm79prpG2C9ZxRRloI9/fVtkcQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)