UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ac1saBbtWE3qfn5rIc/ysCYZPGmQTm6qGSoR21bMM3o='
WHERE
key_id = '4927228dca48efaf5e93472fa161b0cfb15efab376f0d8aa16aed56b8af3bdc4'
AND (
token = 'ac1saBbtWE3qfn5rIc/ysCYZPGmQTm6qGSoR21bMM3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)