UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dH85X9ylolJ7Rsa3jEgEG23jf/32QDs3Yll4O9tGrxE='
WHERE
key_id = '29e9b0b1a03a2880d3e9e708f28629e43185006825425bff94eee330b3223fd7'
AND (
token = 'dH85X9ylolJ7Rsa3jEgEG23jf/32QDs3Yll4O9tGrxE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)