UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qYBo2PZIyUE3mRTk4oJLFr/cj1tO6IkPi256OvREsIY='
WHERE
key_id = 'b3d20e95457dbd2cbc4eed116557a0b3b75b15ce387457aa47c190c492e27ecf'
AND (
token = 'qYBo2PZIyUE3mRTk4oJLFr/cj1tO6IkPi256OvREsIY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)