UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0I22PbKUKsq7Heg2/Fb8AlBnTA5rIz+9gug9PKhljaI='
WHERE
key_id = '3be02165e3cf73f692ad9cdd1f692e2cdeb4e61cb286cdc268ff2f0b81efdaa3'
AND (
token = '0I22PbKUKsq7Heg2/Fb8AlBnTA5rIz+9gug9PKhljaI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)