UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '24DA3RGpiUhAynPUtRkckAZ0jGEcMUS0sj00Sfc9CaE='
WHERE
key_id = '4f7f5aee2d02bc8bd1c041b1b16261761622c2c3d8b6770476a4f98495d219f1'
AND (
token = '24DA3RGpiUhAynPUtRkckAZ0jGEcMUS0sj00Sfc9CaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)