UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27aYhOcs37fqNsO7tLQ1Ui6S3ggVA2FLnUztc2N29o8='
WHERE
key_id = 'dd975f6aa995518e2b5e8eebf2e1b5919b811a99d5a274abc00bfbed802d5950'
AND (
token = '27aYhOcs37fqNsO7tLQ1Ui6S3ggVA2FLnUztc2N29o8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)