UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6fM5FoHTmS3jfU6ZHepUCfSM7NUqvsg3FBm5KbfpKbc='
WHERE
key_id = '4a2f4ea0e6de147d8aa97d188043081702aa0e759aebb59eb63e7b875e5654ec'
AND (
token = '6fM5FoHTmS3jfU6ZHepUCfSM7NUqvsg3FBm5KbfpKbc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)