UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JgPjOy5ThOuxxgqmGAnERLaMPWtTGhghulAgHV9/rB8='
WHERE
key_id = 'f133d30499cf1a7456d84a59c684f2e35aa5229fe7811f33c3c1e7d2eea8730c'
AND (
token = 'JgPjOy5ThOuxxgqmGAnERLaMPWtTGhghulAgHV9/rB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)