UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1yE2hmmSfD7RL0KdGnwdBhzytbf/9Wykwqzg0t5X49I='
WHERE
key_id = 'a9c7dedbfc24a7ffa8e37856099866321eec4892b2b6f2250c9588797f3a2e72'
AND (
token = '1yE2hmmSfD7RL0KdGnwdBhzytbf/9Wykwqzg0t5X49I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)